{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Initial imports\n",
    "import numpy as np\n",
    "import pandas as pd \n",
    "from pandas import DataFrame, Series\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "from scipy import stats\n",
    "%matplotlib inline\n",
    "\n",
    "import random\n",
    "import urllib.request\n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('Complete/CompleteDataset.csv')\n",
    "position_data = pd.read_csv('Complete/PlayerPlayingPositionData.csv')\n",
    "basic_data = pd.read_csv('Complete/basicplayerdata.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = basic_data[['ID', 'Photo']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "f = pd.merge(df1, data, on='ID', how='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Photo_x</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Name</th>\n",
       "      <th>Age</th>\n",
       "      <th>Photo_y</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Flag</th>\n",
       "      <th>Overall</th>\n",
       "      <th>Potential</th>\n",
       "      <th>...</th>\n",
       "      <th>RB</th>\n",
       "      <th>RCB</th>\n",
       "      <th>RCM</th>\n",
       "      <th>RDM</th>\n",
       "      <th>RF</th>\n",
       "      <th>RM</th>\n",
       "      <th>RS</th>\n",
       "      <th>RW</th>\n",
       "      <th>RWB</th>\n",
       "      <th>ST</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>158023</td>\n",
       "      <td>https://cdn.sofifa.org/players/4/18/158023.png</td>\n",
       "      <td>1</td>\n",
       "      <td>L. Messi</td>\n",
       "      <td>30</td>\n",
       "      <td>https://cdn.sofifa.org/48/18/players/158023.png</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>https://cdn.sofifa.org/flags/52.png</td>\n",
       "      <td>93</td>\n",
       "      <td>93</td>\n",
       "      <td>...</td>\n",
       "      <td>57.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20801</td>\n",
       "      <td>https://cdn.sofifa.org/players/4/18/20801.png</td>\n",
       "      <td>0</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>32</td>\n",
       "      <td>https://cdn.sofifa.org/48/18/players/20801.png</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>https://cdn.sofifa.org/flags/38.png</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>...</td>\n",
       "      <td>61.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>190871</td>\n",
       "      <td>https://cdn.sofifa.org/players/4/18/190871.png</td>\n",
       "      <td>2</td>\n",
       "      <td>Neymar</td>\n",
       "      <td>25</td>\n",
       "      <td>https://cdn.sofifa.org/48/18/players/190871.png</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>https://cdn.sofifa.org/flags/54.png</td>\n",
       "      <td>92</td>\n",
       "      <td>94</td>\n",
       "      <td>...</td>\n",
       "      <td>59.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>176580</td>\n",
       "      <td>https://cdn.sofifa.org/players/4/18/176580.png</td>\n",
       "      <td>3</td>\n",
       "      <td>L. Suárez</td>\n",
       "      <td>30</td>\n",
       "      <td>https://cdn.sofifa.org/48/18/players/176580.png</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>https://cdn.sofifa.org/flags/60.png</td>\n",
       "      <td>92</td>\n",
       "      <td>92</td>\n",
       "      <td>...</td>\n",
       "      <td>64.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>167495</td>\n",
       "      <td>https://cdn.sofifa.org/players/4/18/167495.png</td>\n",
       "      <td>4</td>\n",
       "      <td>M. Neuer</td>\n",
       "      <td>31</td>\n",
       "      <td>https://cdn.sofifa.org/48/18/players/167495.png</td>\n",
       "      <td>Germany</td>\n",
       "      <td>https://cdn.sofifa.org/flags/21.png</td>\n",
       "      <td>92</td>\n",
       "      <td>92</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 76 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ID                                         Photo_x  Unnamed: 0  \\\n",
       "0  158023  https://cdn.sofifa.org/players/4/18/158023.png           1   \n",
       "1   20801   https://cdn.sofifa.org/players/4/18/20801.png           0   \n",
       "2  190871  https://cdn.sofifa.org/players/4/18/190871.png           2   \n",
       "3  176580  https://cdn.sofifa.org/players/4/18/176580.png           3   \n",
       "4  167495  https://cdn.sofifa.org/players/4/18/167495.png           4   \n",
       "\n",
       "                Name  Age                                          Photo_y  \\\n",
       "0           L. Messi   30  https://cdn.sofifa.org/48/18/players/158023.png   \n",
       "1  Cristiano Ronaldo   32   https://cdn.sofifa.org/48/18/players/20801.png   \n",
       "2             Neymar   25  https://cdn.sofifa.org/48/18/players/190871.png   \n",
       "3          L. Suárez   30  https://cdn.sofifa.org/48/18/players/176580.png   \n",
       "4           M. Neuer   31  https://cdn.sofifa.org/48/18/players/167495.png   \n",
       "\n",
       "  Nationality                                 Flag  Overall  Potential  ...   \\\n",
       "0   Argentina  https://cdn.sofifa.org/flags/52.png       93         93  ...    \n",
       "1    Portugal  https://cdn.sofifa.org/flags/38.png       94         94  ...    \n",
       "2      Brazil  https://cdn.sofifa.org/flags/54.png       92         94  ...    \n",
       "3     Uruguay  https://cdn.sofifa.org/flags/60.png       92         92  ...    \n",
       "4     Germany  https://cdn.sofifa.org/flags/21.png       92         92  ...    \n",
       "\n",
       "     RB   RCB   RCM   RDM    RF    RM    RS    RW   RWB    ST  \n",
       "0  57.0  45.0  84.0  59.0  92.0  90.0  88.0  91.0  62.0  88.0  \n",
       "1  61.0  53.0  82.0  62.0  91.0  89.0  92.0  91.0  66.0  92.0  \n",
       "2  59.0  46.0  79.0  59.0  88.0  87.0  84.0  89.0  64.0  84.0  \n",
       "3  64.0  58.0  80.0  65.0  88.0  85.0  88.0  87.0  68.0  88.0  \n",
       "4   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "\n",
       "[5 rows x 76 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "f = f.rename(index=str, columns={\"Photo_x\": \"Photo\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "f.drop(['Photo_y', 'Unnamed: 0'], axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Age</th>\n",
       "      <th>Overall</th>\n",
       "      <th>Potential</th>\n",
       "      <th>Special</th>\n",
       "      <th>CAM</th>\n",
       "      <th>CB</th>\n",
       "      <th>CDM</th>\n",
       "      <th>CF</th>\n",
       "      <th>CM</th>\n",
       "      <th>...</th>\n",
       "      <th>RB</th>\n",
       "      <th>RCB</th>\n",
       "      <th>RCM</th>\n",
       "      <th>RDM</th>\n",
       "      <th>RF</th>\n",
       "      <th>RM</th>\n",
       "      <th>RS</th>\n",
       "      <th>RW</th>\n",
       "      <th>RWB</th>\n",
       "      <th>ST</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>15405.000000</td>\n",
       "      <td>15405.000000</td>\n",
       "      <td>15405.000000</td>\n",
       "      <td>15405.000000</td>\n",
       "      <td>15405.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "      <td>13645.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>207669.026615</td>\n",
       "      <td>25.137098</td>\n",
       "      <td>66.822590</td>\n",
       "      <td>71.702110</td>\n",
       "      <td>1606.033561</td>\n",
       "      <td>59.776768</td>\n",
       "      <td>56.129498</td>\n",
       "      <td>57.501649</td>\n",
       "      <td>59.528252</td>\n",
       "      <td>59.100989</td>\n",
       "      <td>...</td>\n",
       "      <td>57.588128</td>\n",
       "      <td>56.129498</td>\n",
       "      <td>59.100989</td>\n",
       "      <td>57.501649</td>\n",
       "      <td>59.528252</td>\n",
       "      <td>60.605203</td>\n",
       "      <td>58.653939</td>\n",
       "      <td>59.872188</td>\n",
       "      <td>58.322462</td>\n",
       "      <td>58.653939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>31371.133629</td>\n",
       "      <td>4.508571</td>\n",
       "      <td>6.864503</td>\n",
       "      <td>6.086678</td>\n",
       "      <td>273.257835</td>\n",
       "      <td>9.861426</td>\n",
       "      <td>12.160434</td>\n",
       "      <td>10.211230</td>\n",
       "      <td>9.932358</td>\n",
       "      <td>8.799248</td>\n",
       "      <td>...</td>\n",
       "      <td>9.704794</td>\n",
       "      <td>12.160434</td>\n",
       "      <td>8.799248</td>\n",
       "      <td>10.211230</td>\n",
       "      <td>9.932358</td>\n",
       "      <td>9.324881</td>\n",
       "      <td>9.183150</td>\n",
       "      <td>9.985027</td>\n",
       "      <td>9.037688</td>\n",
       "      <td>9.183150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>16.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>46.000000</td>\n",
       "      <td>48.000000</td>\n",
       "      <td>728.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>32.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>193076.000000</td>\n",
       "      <td>22.000000</td>\n",
       "      <td>62.000000</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>1464.000000</td>\n",
       "      <td>54.000000</td>\n",
       "      <td>46.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>53.000000</td>\n",
       "      <td>53.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>46.000000</td>\n",
       "      <td>53.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>53.000000</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>52.000000</td>\n",
       "      <td>54.000000</td>\n",
       "      <td>52.000000</td>\n",
       "      <td>52.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>213170.000000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>71.000000</td>\n",
       "      <td>1648.000000</td>\n",
       "      <td>61.000000</td>\n",
       "      <td>58.000000</td>\n",
       "      <td>58.000000</td>\n",
       "      <td>61.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>58.000000</td>\n",
       "      <td>58.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>58.000000</td>\n",
       "      <td>61.000000</td>\n",
       "      <td>62.000000</td>\n",
       "      <td>59.000000</td>\n",
       "      <td>61.000000</td>\n",
       "      <td>59.000000</td>\n",
       "      <td>59.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>230473.000000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>71.000000</td>\n",
       "      <td>76.000000</td>\n",
       "      <td>1797.000000</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>65.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>241218.000000</td>\n",
       "      <td>44.000000</td>\n",
       "      <td>94.000000</td>\n",
       "      <td>94.000000</td>\n",
       "      <td>2291.000000</td>\n",
       "      <td>92.000000</td>\n",
       "      <td>87.000000</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>92.000000</td>\n",
       "      <td>87.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>84.000000</td>\n",
       "      <td>87.000000</td>\n",
       "      <td>87.000000</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>92.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>92.000000</td>\n",
       "      <td>91.000000</td>\n",
       "      <td>84.000000</td>\n",
       "      <td>92.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  ID           Age       Overall     Potential       Special  \\\n",
       "count   15405.000000  15405.000000  15405.000000  15405.000000  15405.000000   \n",
       "mean   207669.026615     25.137098     66.822590     71.702110   1606.033561   \n",
       "std     31371.133629      4.508571      6.864503      6.086678    273.257835   \n",
       "min        16.000000     16.000000     46.000000     48.000000    728.000000   \n",
       "25%    193076.000000     22.000000     62.000000     67.000000   1464.000000   \n",
       "50%    213170.000000     25.000000     67.000000     71.000000   1648.000000   \n",
       "75%    230473.000000     28.000000     71.000000     76.000000   1797.000000   \n",
       "max    241218.000000     44.000000     94.000000     94.000000   2291.000000   \n",
       "\n",
       "                CAM            CB           CDM            CF            CM  \\\n",
       "count  13645.000000  13645.000000  13645.000000  13645.000000  13645.000000   \n",
       "mean      59.776768     56.129498     57.501649     59.528252     59.100989   \n",
       "std        9.861426     12.160434     10.211230      9.932358      8.799248   \n",
       "min       27.000000     25.000000     26.000000     27.000000     31.000000   \n",
       "25%       54.000000     46.000000     50.000000     53.000000     53.000000   \n",
       "50%       61.000000     58.000000     58.000000     61.000000     60.000000   \n",
       "75%       67.000000     66.000000     65.000000     66.000000     65.000000   \n",
       "max       92.000000     87.000000     85.000000     92.000000     87.000000   \n",
       "\n",
       "           ...                 RB           RCB           RCM           RDM  \\\n",
       "count      ...       13645.000000  13645.000000  13645.000000  13645.000000   \n",
       "mean       ...          57.588128     56.129498     59.100989     57.501649   \n",
       "std        ...           9.704794     12.160434      8.799248     10.211230   \n",
       "min        ...          30.000000     25.000000     31.000000     26.000000   \n",
       "25%        ...          50.000000     46.000000     53.000000     50.000000   \n",
       "50%        ...          58.000000     58.000000     60.000000     58.000000   \n",
       "75%        ...          65.000000     66.000000     65.000000     65.000000   \n",
       "max        ...          84.000000     87.000000     87.000000     85.000000   \n",
       "\n",
       "                 RF            RM            RS            RW           RWB  \\\n",
       "count  13645.000000  13645.000000  13645.000000  13645.000000  13645.000000   \n",
       "mean      59.528252     60.605203     58.653939     59.872188     58.322462   \n",
       "std        9.932358      9.324881      9.183150      9.985027      9.037688   \n",
       "min       27.000000     28.000000     32.000000     26.000000     31.000000   \n",
       "25%       53.000000     55.000000     52.000000     54.000000     52.000000   \n",
       "50%       61.000000     62.000000     59.000000     61.000000     59.000000   \n",
       "75%       66.000000     67.000000     65.000000     67.000000     65.000000   \n",
       "max       92.000000     90.000000     92.000000     91.000000     84.000000   \n",
       "\n",
       "                 ST  \n",
       "count  13645.000000  \n",
       "mean      58.653939  \n",
       "std        9.183150  \n",
       "min       32.000000  \n",
       "25%       52.000000  \n",
       "50%       59.000000  \n",
       "75%       65.000000  \n",
       "max       92.000000  \n",
       "\n",
       "[8 rows x 31 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "f.to_csv('Complete/CompleteDataset.csv', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID                     False\n",
       "Photo                  False\n",
       "Name                   False\n",
       "Age                    False\n",
       "Nationality            False\n",
       "Flag                   False\n",
       "Overall                False\n",
       "Potential              False\n",
       "Club                    True\n",
       "Club Logo              False\n",
       "Value                  False\n",
       "Wage                   False\n",
       "Special                False\n",
       "Acceleration           False\n",
       "Aggression             False\n",
       "Agility                False\n",
       "Balance                False\n",
       "Ball control           False\n",
       "Composure              False\n",
       "Crossing               False\n",
       "Curve                  False\n",
       "Dribbling              False\n",
       "Finishing              False\n",
       "Free kick accuracy     False\n",
       "GK diving              False\n",
       "GK handling            False\n",
       "GK kicking             False\n",
       "GK positioning         False\n",
       "GK reflexes            False\n",
       "Heading accuracy       False\n",
       "                       ...  \n",
       "Strength               False\n",
       "Vision                 False\n",
       "Volleys                False\n",
       "CAM                     True\n",
       "CB                      True\n",
       "CDM                     True\n",
       "CF                      True\n",
       "CM                      True\n",
       "LAM                     True\n",
       "LB                      True\n",
       "LCB                     True\n",
       "LCM                     True\n",
       "LDM                     True\n",
       "LF                      True\n",
       "LM                      True\n",
       "LS                      True\n",
       "LW                      True\n",
       "LWB                     True\n",
       "Preferred Positions    False\n",
       "RAM                     True\n",
       "RB                      True\n",
       "RCB                     True\n",
       "RCM                     True\n",
       "RDM                     True\n",
       "RF                      True\n",
       "RM                      True\n",
       "RS                      True\n",
       "RW                      True\n",
       "RWB                     True\n",
       "ST                      True\n",
       "Length: 74, dtype: bool"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.isnull(f).sum() > 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
